How to: Create a query using the Query Wizards.
Solution:
Click the 'Queries' tab in the Database window, click 'New', and select the type of query wizard from the list box.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Click 'New'. (The New Query dialog box appears.)
4) Select the desired query wizard from the list box.
Select wizard
NOTE 1: Do not select 'Design View'. This will display the Query Design view, with no wizards to help in the query design.
NOTE 2: There are four query wizards available: 'Simple Query Wizard', 'Crosstab Query Wizard', 'Find Duplicates Query Wizard', and 'Find UnMatched Query Wizard'.
5) Click 'OK'. (The selected wizard appears.)
6) Follow the instructions that appear for the selected query wizard.
NOTE: Click 'Next' after selections and entries are made in each dialog box to go to the next step.
7) Click 'Finish' when all selections and entries have been made. (The results appear in a 'Datasheet View' window.)
